package com.swust.book_shop.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.swust.book_shop.pojo.BookInfo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.swust.book_shop.pojo.vo.BookItemVo;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

/**
* @author 86151
* @description 针对表【book_info】的数据库操作Mapper
* @createDate 2022-05-04 23:16:39
* @Entity com.swust.book_shop.pojo.BookInfo
*/
public interface BookInfoMapper extends BaseMapper<BookInfo> {

    IPage<BookItemVo> queryBookItemLimit(IPage<BookItemVo> iPage);

    IPage<BookItemVo> queryBookItemLimitByPriceOrName(@Param("iPage") IPage<BookItemVo> iPage, @Param("bookName") String bookName, @Param("low") BigDecimal low,@Param("high") BigDecimal high);

    IPage<BookItemVo> queryBookByCategory(@Param("iPage") IPage<BookItemVo> iPage,@Param("bookCategory") String bookCategory);

}




